MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

22 rows where Object Name = 392

View and edit SQL

Suggested facets: Is Public Domain, Department, Culture, Artist Nationality, Object Date, Object Begin Date, Object End Date, Medium, Credit Line

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
3245 1985.40.13 0 0 3474 American Decorative Arts 1 Duster 392 Duster American, Shaker 5                           1800–1900 1800 1900 Wood; Cherry, lambswool, string, cloth, brass wire 706 H. 12 1/2 in. (31.8 cm) Gift of Mrs. G. James Fawcett, in memory of John S. Rudd, 1985 Made in 1 New Lebanon 13     United States 3             Natural Substances 6   Metropolitan Museum of Art, New York, NY 1
70211 C.I.39.49.2a, b 0 1 84075 Costume Institute 8 Duster 392 Duster American 1                           1860–65 1860 1865 linen 15098   Gift of Mrs. W. H. Chamberlain, 1939                           Metropolitan Museum of Art, New York, NY 1
70415 C.I.42.74.5a, b 0 0 84370 Costume Institute 8 Duster 392 Duster American 1                           ca. 1910 1905 1915 linen 15098   Gift of Miss Genevieve Karr Hamlin, 1942                           Metropolitan Museum of Art, New York, NY 1
70419 1972.209.44 0 0 84374 Costume Institute 8 Duster 392 Duster American 1                           ca. 1910 1905 1915 linen 15098   Gift of C.J. Vincente Minetti, 1972                           Metropolitan Museum of Art, New York, NY 1
73512 C.I.50.42.1 0 0 91987 Costume Institute 8 Duster 392 Duster American 1                           1905 1905 1905 mohair, cotton 16779   Gift of Miss Ruth Payne Burgess, 1950                           Metropolitan Museum of Art, New York, NY 1
73516 C.I.69.31.6 0 0 91991 Costume Institute 8 Duster 392 Duster American 1                           ca. 1910 1900 1920 linen 15098   Gift of Mrs. James S. Hedges, 1969                           Metropolitan Museum of Art, New York, NY 1
73518 1975.138.23 0 0 91993 Costume Institute 8 Duster 392 Duster British 6                           early 20th century 1900 1925 cotton, linen 15096   Gift of Eleanora Eaton Brooks, 1975                           Metropolitan Museum of Art, New York, NY 1
79362 1975.248.13a, b 0 0 106466 Costume Institute 8 Duster 392 Duster French 7                           early 20th century 1900 1950 wool, silk 15161   Gift of Mrs. William Floyd Nichols and Mrs. B. Langdon Tyler, 1975                           Metropolitan Museum of Art, New York, NY 1
79367 C.I.50.42.2 0 0 106479 Costume Institute 8 Duster 392 Duster American 1         Manufacturer 20   Abercrombie and Fitch Co.     Abercrombie and Fitch Co. 6091 American 1 1892 2050 1905 1905 1905 cotton 3340   Gift of Miss Ruth Payne Burgess, 1950                           Metropolitan Museum of Art, New York, NY 1
79369 C.I.54.56.3 0 0 106481 Costume Institute 8 Duster 392 Duster American or European 48                           ca. 1901 1896 1906 linen 15098   Gift of Alan Wolfe, 1954                           Metropolitan Museum of Art, New York, NY 1
79372 C.I.65.30.6 0 0 106485 Costume Institute 8 Duster 392 Duster American 1                           1904–5 1904 1905 linen 15098   Gift of the Heirs of Maud van Cortlandt Taylor Hill, 1965                           Metropolitan Museum of Art, New York, NY 1
79524 1979.264 0 1 106763 Costume Institute 8 Duster 392 Duster French 7         Designer 5   Revillon Frères French, founded 1723   Revillon Frères 5632 French 2 1723 1850 1914–20 1914 1920 silk 15101   Gift of Charles D. Wood in honor of Kathryn Wood, 1979                           Metropolitan Museum of Art, New York, NY 1
79525 1979.336.8 0 0 106764 Costume Institute 8 Duster 392 Duster American or European 48                           1908–10 1908 1910 silk 15101   Gift of Louise Nevelson, 1979                           Metropolitan Museum of Art, New York, NY 1
79527 C.I.41.137.7 0 0 106768 Costume Institute 8 Duster 392 Duster American 1                           1910–15 1910 1915 linen 15098   Gift of Miss Hannah McAllister, 1941                           Metropolitan Museum of Art, New York, NY 1
79687 C.I.40.110.4 0 0 107104 Costume Institute 8 Duster 392 Duster American or European 48                           1915–20 1915 1920 wool, silk 15161   Gift of Mrs. E. E. Coster, 1940                           Metropolitan Museum of Art, New York, NY 1
86856 C.I.44.100.1 0 1 122987 Costume Institute 8 Duster 392 Duster American 1                           1880s 1880 1889 cotton 3340   Gift of Miss Lucile Abbey, 1944                           Metropolitan Museum of Art, New York, NY 1
87439 2005.323.13 0 0 124788 Costume Institute 8 Duster 392 Duster Japanese 35         Designer|Design House 202   Issey Miyake|Miyake Design Studio Japanese, born 1938|Japanese   Miyake Issey|Miyake Design Studio 5319 Japanese|Japanese 72 1938 2038 ca. 1984 1979 1989 linen, plastic 15872   Gift of Muriel Kallis Newman, 2005                           Metropolitan Museum of Art, New York, NY 1
92993 2009.300.663 0 0 159219 Costume Institute 8 Duster 392 Duster American 1                           1910 1910 1910 silk 15101   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mary Mabon Shively, 1941                           Metropolitan Museum of Art, New York, NY 1
93212 2009.300.860 0 0 159438 Costume Institute 8 Duster 392 Duster American 1         Department Store 208   Rogers, Peet & Company American, founded 1874   Rogers, Peet & Company 6893 American 1 1874 1974 1900–1910 1900 1910 wool 15104   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Charles L. Livingston, Jr., 1962                           Metropolitan Museum of Art, New York, NY 1
93248 2009.300.893a, b 0 0 159474 Costume Institute 8 Duster 392 Duster American 1                           1900–1915 1900 1915 linen 15098   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; GIft of Frieda Sherman, 1965                           Metropolitan Museum of Art, New York, NY 1
96318 2009.300.6480 0 1 173500 Costume Institute 8 Duster 392 Duster American 1         Maker 1   Joseph Yeska American, 1860–1920   Yeska, Joseph 7741 American 1 1860 1920 1905–15 1905 1915 Cotton 2154   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Frank L. Babbott, Jr., 1941                           Metropolitan Museum of Art, New York, NY 1
97406 2009.300.7746a–c 0 0 174785 Costume Institute 8 Duster 392 Duster American 1         Retailer 8   Gimbel Brothers American, 1887–1987   Gimbel Brothers 7665 American 1 1887 1987 ca. 1912 1910 1914 Silk 165   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Philip J. Roosevelt, 1969                           Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 141.892ms · Data license: CC0 · Data source: metmuseum/openaccess